﻿CREATE TABLE [dbo].[Road] (
    [Road_ID]      INT           IDENTITY (1, 1) NOT NULL,
    [Code]         VARCHAR (50)  NOT NULL,
    [Mnemocode]    VARCHAR (50)  NULL,
    [Name]         VARCHAR (100) NULL,
    [ShortName]    VARCHAR (20)  NULL,
    [MnemocodeEng] VARCHAR (50)  NULL,
    [NameEng]      VARCHAR (110) NULL,
    [ShortNameEng] VARCHAR (25)  NULL,
    CONSTRAINT [PK_Road] PRIMARY KEY CLUSTERED ([Road_ID] ASC),
    CONSTRAINT [Code_Road] UNIQUE NONCLUSTERED ([Code] ASC)
);

